UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B5w5bFrB4WGkDm/3Koaucb7Y8hBh0WyrpS05wokeI70='
WHERE
key_id = 'ad0f219e807d92200ed63fcb424f9ca6c975a14c7a896189e8748d0baa311eb2'
AND (
token = 'B5w5bFrB4WGkDm/3Koaucb7Y8hBh0WyrpS05wokeI70='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)