UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2yMW8lCXrqnx0qb249Sajoy4NzsYXQk6gsIIlSz30Kg='
WHERE
key_id = 'a48fefe5168dfbc21189a1ad59fcb9d999341f7eb735450e7f19233c282146dc'
AND (
token = '2yMW8lCXrqnx0qb249Sajoy4NzsYXQk6gsIIlSz30Kg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)