UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n9zb4d5NT0ED8FNgHFubKQYYT3pU1zGlg7CjjGgQikA='
WHERE
key_id = 'fcda521abb6c1866c504b7995553ebd516b368eef8a63e2157b2742ff25217e4'
AND (
token = 'n9zb4d5NT0ED8FNgHFubKQYYT3pU1zGlg7CjjGgQikA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)