UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kKj7L4Tz6E615LkB762rFOv0fe1cjPU9E42If4Ajzlk='
WHERE
key_id = '500d8b280cd58e9e545a06ea6e11d5136a470c909e17b098590a5ebc887c9d1a'
AND (
token = 'kKj7L4Tz6E615LkB762rFOv0fe1cjPU9E42If4Ajzlk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)