UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tKVxg8T7Reavmy1fxhjKrMFENwXa153wB2XVQx1kMqE='
WHERE
key_id = '27e6f6cd5be34f915bfe54c9fea64a01b3a183ec4600159aa0df2729c2f24381'
AND (
token = 'tKVxg8T7Reavmy1fxhjKrMFENwXa153wB2XVQx1kMqE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)