UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WXT0i+vSHVj76QLg58GpAIUOX+mgI1R3jrs5tWDv77s='
WHERE
key_id = '0024a6c64f9cd85fa1d4dfdbdd2c2d5bf21119b99f48d4f84cb7bd466bf929bd'
AND (
token = 'WXT0i+vSHVj76QLg58GpAIUOX+mgI1R3jrs5tWDv77s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)