UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'liN+yViy/TjEtn6ade/VGiTjTTOE0e6m8xywgU4p1Tc='
WHERE
key_id = '9e3f455e40012a960fea895282ee133728515d433518ff5e5834ee78508b8dc0'
AND (
token = 'liN+yViy/TjEtn6ade/VGiTjTTOE0e6m8xywgU4p1Tc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)