UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lfnR8bORD1B4hmrDJE25XvR4G8NlgUDExqjMYuzWot4='
WHERE
key_id = '7a646c89b576dac428059b49ebc6b7e222ed93a0c4f58427cdb6238d705b7eb5'
AND (
token = 'lfnR8bORD1B4hmrDJE25XvR4G8NlgUDExqjMYuzWot4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)