UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wZTaAPdUjc6R38f1EHfkKe6VPpsJ6M07sa8cC04pLqA='
WHERE
key_id = '9ea70ddf31c49fd40f8e94fab5b28ef31960ce711306c551dba095512a6f5388'
AND (
token = 'wZTaAPdUjc6R38f1EHfkKe6VPpsJ6M07sa8cC04pLqA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)