UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kNT7jSw1d94UnpTV4GV50T7bxbVceBECIvQdPa5dGnE='
WHERE
key_id = 'b1892a5b2747e237f6e16dabe78747590448da791416e16b294cbe2a501e8b4a'
AND (
token = 'kNT7jSw1d94UnpTV4GV50T7bxbVceBECIvQdPa5dGnE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)