UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NBTOggtWgRzj30a9fDL0P/igs7By1voFRMP9kHGSjqU='
WHERE
key_id = 'f50483187d44a8c54f05d7eb956b89bb31ea90425be5e2367b6ebaadd6047eaf'
AND (
token = 'NBTOggtWgRzj30a9fDL0P/igs7By1voFRMP9kHGSjqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)