UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XFC7ZgUOA3cQnP7xD5Ytq63NDwxxWvNOiNRPyfxN+aU='
WHERE
key_id = '8c07366d379c2d89d88595dbc989a6b42b0b399ebb3592068ad4f27eec0ae2a4'
AND (
token = 'XFC7ZgUOA3cQnP7xD5Ytq63NDwxxWvNOiNRPyfxN+aU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)