UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W9G+pneE0KqVKZhuCObSGZhT8D9/kf9L0Y4IlmmDl24='
WHERE
key_id = 'a29c7007e9ee94a2953eef3496130aadbc3851732b53ab940780c186d5a62434'
AND (
token = 'W9G+pneE0KqVKZhuCObSGZhT8D9/kf9L0Y4IlmmDl24='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)