UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ImtD4V8t91T6QGDKUdNuzkNTaGMeV/yUI9j65mo0I0='
WHERE
key_id = '8ec62168901b00fe9e68b353d3c14d4d08495e1070b547f57bb5d4ae153d30a2'
AND (
token = '8ImtD4V8t91T6QGDKUdNuzkNTaGMeV/yUI9j65mo0I0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)