UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9wcD9BrL6YQFnXtw+FodWDpKd7zurNlCnrwxaftceMk='
WHERE
key_id = '31386632f6b9d92a8f2fab14a2595f9feebe8547858eca5aa5013878cc7d7083'
AND (
token = '9wcD9BrL6YQFnXtw+FodWDpKd7zurNlCnrwxaftceMk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)