UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C4yaWgCcWeEZZd01if8Np3WifTxtNzY/wsu/RS4Ro5o='
WHERE
key_id = 'a8527bbcbf346496710ae67badc31d87e83d4174342ee7b4cb93d1a1c4b264fc'
AND (
token = 'C4yaWgCcWeEZZd01if8Np3WifTxtNzY/wsu/RS4Ro5o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)