UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'osIp5d1ge1OGqiXG+fYzcDYBO4i+gyrkqjXbS4uMjJg='
WHERE
key_id = 'bc46f7a08e4efd8c42266c4d5a9fa1d1dd0a4445a0c17cd570e24eda511932d9'
AND (
token = 'osIp5d1ge1OGqiXG+fYzcDYBO4i+gyrkqjXbS4uMjJg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)