UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zvPNx4cyuO9NCZVvedCRJv5ttHPk6AZ6fwwFTHI4Iws='
WHERE
key_id = '646db9f99b1a7a31f39bb95f3f6e5500e7514130137383a3af8479a50bce8ec1'
AND (
token = 'zvPNx4cyuO9NCZVvedCRJv5ttHPk6AZ6fwwFTHI4Iws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)