UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Ll8iOlqePjfY0+fT5n5i4JfSa7lx8CZ044GSM2hlbs='
WHERE
key_id = 'd303d4e4efc8e50b350b03638640fae922a7809a7d98bc02cc90078705637870'
AND (
token = '8Ll8iOlqePjfY0+fT5n5i4JfSa7lx8CZ044GSM2hlbs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)