UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zBP/xzktZkrYvZ11EwD7uTf0ZBetMrYvUjeahjEmrp8='
WHERE
key_id = '3d9c7be8d3c5a69ad6fddfb3daea3574a968578adf61a1b92f88492fcfa79f77'
AND (
token = 'zBP/xzktZkrYvZ11EwD7uTf0ZBetMrYvUjeahjEmrp8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)