UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2hDLaHVLYlw6ODtQw+5WPGpp8tIUwTe87biG9j1bh6U='
WHERE
key_id = '734d4f2c98e0688987d6ee754529fe7584adb66b86b7c685c56fb59dda1c025d'
AND (
token = '2hDLaHVLYlw6ODtQw+5WPGpp8tIUwTe87biG9j1bh6U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)