UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8rFF5P7NDwxjDDCZPSbSAWMLaJOLlfgoRAaeZ7Vxxac='
WHERE
key_id = '7b588ee5f6a91ea0cfec7c1d09b8e060ccda961657e1c2d45cf4dfce9376d409'
AND (
token = '8rFF5P7NDwxjDDCZPSbSAWMLaJOLlfgoRAaeZ7Vxxac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)