UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qbwCtglfFjP+j3j4+BnC/zuYEntE7gsyg13zpmc9Xwk='
WHERE
key_id = 'a8808e24105512e7adfb97b465c7aa3ce4565adbcb5fd0f0fe20fd3885c78d9a'
AND (
token = 'qbwCtglfFjP+j3j4+BnC/zuYEntE7gsyg13zpmc9Xwk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)