UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UEabdIOkKHdwG4TtFgAQjwmtyb7qZKOwOaFPG5iuMCA='
WHERE
key_id = '1731a9b55cd2ad840197f5dfa037c7fc2d1b0a949ffa04ac04b68909e47c71c4'
AND (
token = 'UEabdIOkKHdwG4TtFgAQjwmtyb7qZKOwOaFPG5iuMCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)