UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JafuMS6CIfrUBMJsGuGm3OKvvTYm63+i+oKTQBeqaA4='
WHERE
key_id = '8c67baec1f65418a82a01f21cc91330af7fd11e2582bbb7f60473f62c8e8a98b'
AND (
token = 'JafuMS6CIfrUBMJsGuGm3OKvvTYm63+i+oKTQBeqaA4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)