UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PetMPtc3+GdMbt33kP9GpbZ0aoiv6zJEOzAOt0tcYE4='
WHERE
key_id = 'f3992042a39b08e5da02ca30e34c424951e3edb661e0d81a473b6988f249ba80'
AND (
token = 'PetMPtc3+GdMbt33kP9GpbZ0aoiv6zJEOzAOt0tcYE4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)