UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N33B5Lj6hWt1ghMzeu5pdDdQCcKhJ7cG9uEYPMW7mWA='
WHERE
key_id = 'e7c3261d63f44ac2d6f5c4b2f156c218b3f2c8f654af3ae7f57433c59a2ccc8f'
AND (
token = 'N33B5Lj6hWt1ghMzeu5pdDdQCcKhJ7cG9uEYPMW7mWA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)