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